Microsoft Excel Q/a Practice Questions Answers Test With Solutions & More Shortcuts

Question : 1

Which of the following is not a valid data type in Excel?

a) Number

b) Character

c) Label

d) Date/Time

e) None of these

Question : 2

In Excel the function calculates depreciation at the same amount each year over an asset’s useful life

a) DB (fixed-declining balance)

b) SLN (straight line)

c) DDB (double-declining)

d) All of above

Question : 3

Which of the following is not true about Find and Replace in Excel

a) You can search for bold and replace with italics

b) You can decide whether to look for the whole word or not

c) You can search in formula too

d) You can search by rows or columns or sheets

e) None of these

Question : 4

A worksheet range is a

a) A command used for data modeling

b) A range of values such as from 23 to 234

c) A group of cells

d) A group of worksheets

Question : 5

Which of the following is not a way to complete a cell entry?

a) Pressing enter

b) Pressing any arrow key on the keyboard

c) Clicking the Enter button on the Formula bar

d) Pressing spacebar

e) None of these